﻿
-- 人员排班信息增加
create procedure [dbo].[RypbInfo_Add]
@sfzh varchar(18),
@xm varchar(10),
@qybmm varchar(100),
@pbsj datetime,
@bcid int
as
if not exists(select 1 from Rypb_Info where sfzh=@sfzh and pbsj=@pbsj)
begin
insert into Rypb_Info(sfzh,xm,qybmm,pbsj,bcid) values (@sfzh,@xm,@qybmm,@pbsj,@bcid)
end